IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sp_ChiNhanh_GopTenVaDiaChi]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_ChiNhanh_GopTenVaDiaChi]
GO


CREATE PROC [sp_ChiNhanh_GopTenVaDiaChi]
AS	
BEGIN
	SELECT ID,Ten + ' - ' + Dia_chi AS 'Chi_nhanh'
	FROM ChiNhanh
END